const goodsSQL = {
    queryAll: 'SELECT * FROM goods',   // 查询所有商品
    insert: 'insert into goods(id,username,password,nickname,identity,gender,age,createTime,updateTime) values(?,?,?,?,?,?,?,?,?)',  // 插入新用户
    deleteGoods: 'delete from goods where goods_id=?', // 删除用户
    updateSelect:'update goods set sub_select=? where goods_id=?',
    updateAdminGoods:'update goods set admin_select=? where goods_id=?',
    updateGoods:'update goods set campuls=?,category=?,quality_type=?,price=?,email=?,phone=?,title=? where goods_id=?',
    updateComment:'update goods set comment=? where goods_id=?'
}

module.exports = goodsSQL
